| |
189 Search Results Found |
| 1 |
Forum: Marketplace «»
Posted on: Fri, 12 June 2020 12:15 «»
By: Michel Cadot
Re: McDP: like expdp/impdp Data Pump programs and much more
…
DESCRIBE command
The DESCRIBE command is another way to get information about a Data Pump job.
The syntaxes of this command are:
McDP [<logon>] { -desc | --describe } [<schema>.]<dp job> [[-opt] <display/trace option>]
…
|
| 2 |
Forum: Forms «»
Posted on: Sat, 13 August 2022 03:29 «»
By: sasipalarivattom
Re: Files generated on server with sufix
…report in URL
like http://WIN-SERV:9002/reports/rwservlet?server=rep_server1&report=test.rdf&destype=file&desformat=html&userid=scott/ti ger@orcl&desname=c:\rep1.html
is it also appending something to the output file…
|
| 3 |
Forum: Reports & Discoverer «»
Posted on: Wed, 05 December 2007 05:17 «»
By: jitender.sadh
Re: calling report 6i from database trigger
…ok, is there any other method to call a report from database without using Java Stored Procedure, my mean by using any oracle built in package .
actualy i am trying to run the report by using following code in oracle 8i
1)create or replace trigger …
|
| 4 |
Forum: Server Administration «»
Posted on: Thu, 22 November 2007 00:53 «»
By: Michel Cadot
Re: Exporting Data from a partitioned table
…Export: Release 10.2.0.3.0 - Production on Thu Nov 22 07:51:04 2007
Copyright (c) 1982, 2005, Oracle. All rights reserved.
You can let Export prompt you for parameters by entering the EXP
command followed by your username/password:
…
|
| 5 |
Forum: Reports & Discoverer «»
Posted on: Thu, 22 November 2007 00:15 «»
By: Littlefoot
Re: attach report to window schedular
Create a DOS batch file which would look like this example:c:\orant\bin\rwrun60.exe userid=scott/tiger@orcl report=your_report_name
Then schedule this batch file.
|
| 6 |
Forum: Server Utilities «»
Posted on: Mon, 12 November 2007 04:57 «»
By: Michel Cadot
Re: select table from dump
…C:\>imp help=y
Import: Release 10.2.0.3.0 - Production on Mon Nov 12 11:56:42 2007
Copyright (c) 1982, 2005, Oracle. All rights reserved.
You can let Import prompt you for parameters by entering the IMP
command followed by your username/…
|
| 7 |
Forum: Forms «»
Posted on: Mon, 15 October 2007 06:12 «»
By: tenny
Re: Forms 10G
…DF&destype=cache'||
'&userid=scott23/lion@acl¶mform=no' ;
WEB.SHOW_DOCUMENT(p_rep_url,'_blank');
END;
i have already set reports_path and rep_fsprod server is also runing, but still following errors are raised
…
|
| 8 |
Forum: Linux «»
Posted on: Mon, 15 October 2007 05:18 «»
By: Michel Cadot
Re: Importing dump to oracle database
…help=y
Import: Release 10.2.0.3.0 - Production on Mon Oct 15 12:17:45 2007
Copyright (c) 1982, 2005, Oracle. All rights reserved.
You can let Import prompt you for parameters by entering the IMP
command followed by your username/password…
|
| 9 |
Forum: Server Utilities «»
Posted on: Mon, 01 October 2007 01:47 «»
By: Littlefoot
Re: datapump export substitution variables
…
c:\oracle\product\10.2.0\db_1\bin\exp.exe userid=scott/tiger@orcl file=e:\syr%vdate%.dmp owner=scott
endlocal
echo on
When executed:
c:\> test.bat
c:\oracle\product\10.2.0\db_1\bin\exp.exe userid=scott/tiger@orcl file=e:\syr07_19_2006_803.dmp …
|
| 10 |
Forum: Forms «»
Posted on: Sun, 02 September 2007 02:39 «»
By: mmrz
Re: Error at running forms in oracle form 10g
Sorry for my late reply!
for running a test form(Form Developer/Run a Form on the Web) I entered the scott as a Userid and Webport=1521 or 8888 but nothing will be run and no message show to me.
|
| 11 |
Forum: Forms «»
Posted on: Mon, 27 August 2007 01:52 «»
By: prachi.mgorwadkar
Re: Called Form Debugging
…following help.
ifcmp60 module=myform userid=scott/tiger debug=yes
I am using Forms 6. And I am using it from the last 8 months only.
And I compile as Ctrl + k or Shift+Ctrl+k.
And Run as :- Ctrl+R AND debug as :- Shift+Ctrl+k.
Can you please …
|
| 12 |
Forum: Forms «»
Posted on: Tue, 21 August 2007 16:06 «»
By: kwaam_rak
Re: Installing Developer 10G suite on Windows Vista
…
Yes, I have access to scott/tiger@devt.
I continued to read further on orafaq and found out that I can conceal the connection string from the URL by using the key map file (cgicmd.dat)
And so, I modified the key map file, I added this line…
|
| 13 |
Forum: Server Utilities «»
Posted on: Thu, 02 August 2007 03:05 «»
By: Michel Cadot
Re: Why did the dump file extracted too large?
…C:\>exp help=y
Export: Release 10.2.0.3.0 - Production on Jeu. Ao¹t 2 10:05:18 2007
Copyright (c) 1982, 2005, Oracle. All rights reserved.
You can let Export prompt you for parameters by entering the EXP
command followed by your username…
|
| 14 |
Forum: Server Utilities «»
Posted on: Fri, 06 July 2007 06:27 «»
By: Michel Cadot
Re: Exporting User Schema
…C:\>exp help=y
Export: Release 10.2.0.3.0 - Production on Ven. Juil. 6 13:27:17 2007
Copyright (c) 1982, 2005, Oracle. All rights reserved.
You can let Export prompt you for parameters by entering the EXP
command followed by your …
|
| 15 |
Forum: SQL & PL/SQL «»
Posted on: Thu, 05 July 2007 11:12 «»
By: Barbara Boehmer
Re: Large query with multiple conditional joins
…is best if you add a little section at a time, test and debug until it compiles and executes correctly, then add another little section. When you add a whole bunch of stuff and then try to run it, it will be harder to figure out where the problems are. …
|
| 16 |
Forum: Reports & Discoverer «»
Posted on: Wed, 20 June 2007 03:45 «»
By: aslme
Re: Run Multiple Reports in Oracle Reports 6/6i
…this trigger on any buttons you want by this you can run many reports through single form or menu.
HOST ('CMD /C START RWRUN60 REPORT=' || 'C:\REPORT' || ' USERID=SCOTT/TIGER@ORCL DESTYPE=SCREEN p_client_Code=000004 paramform=no');
Thanks
Cheers…
|
| 17 |
Forum: Windows «»
Posted on: Thu, 14 June 2007 09:26 «»
By: Littlefoot
Re: How to create a dmp file with current system date
…") do set vdate=%vdate%_%%i%%j
exp.exe userid=scott/tiger@ora10lp file=c:\temp\exp%vdate%.dmp
endlocal
echo on
When executed:C:\TEMP>test
Export: Release 10.2.0.1.0 - Production on ╚et Lip 14 16:23:53 2007
Copyright (c) 1982, 2005…
|
| 18 |
Forum: Server Utilities «»
Posted on: Mon, 04 June 2007 05:26 «»
By: Littlefoot
Re: how to load fix length formatted data from a file
… (11:20)
)
SQL>
SQL> $sqlldr userid=scott/tiger@ora10 control=test.ctl log=test.log
SQL*Loader: Release 10.2.0.1.0 - Production on Pon Lip 4 12:25:07 2007
Copyright (c) 1982, 2005, Oracle. All rights reserved.
Commit point reached…
|
| 19 |
Forum: Backup & Recovery «»
Posted on: Sun, 27 May 2007 22:51 «»
By: BlackSwan
Re: IMP-00017: following statement failed with ORACLE error 2237
…
imp help=yes
Import: Release 10.2.0.2.0 - Production on Sun May 27 20:50:30 2007
Copyright (c) 1982, 2005, Oracle. All rights reserved.
You can let Import prompt you for parameters by entering the IMP
command followed by your username/…
|
| 20 |
Forum: SQL & PL/SQL «»
Posted on: Sat, 26 May 2007 00:15 «»
By: Michel Cadot
Re: Can i do this???
…tables of a user:
C:\>exp help=y
Export: Release 10.2.0.3.0 - Production on Sam. Mai 26 07:14:17 2007
Copyright (c) 1982, 2005, Oracle. All rights reserved.
You can let Export prompt you for parameters by entering the EXP
command …
|
| 21 |
Forum: SQL & PL/SQL «»
Posted on: Mon, 21 May 2007 08:08 «»
By: joy_division
Re: import command
…is the help for import (imp). However, if you just run the imp command, it will be interactive and you can just answer the prompts. I hope you will be doing this in a test environment.
FOO SCOTT>!imp help=y
Import: Release 10.1.0.2.0 - …
|
| 22 |
Forum: Server Utilities «»
Posted on: Wed, 16 May 2007 09:57 «»
By: Michel Cadot
Re: exporting procedure-in user mode
…C:\>exp help=y
Export: Release 10.2.0.3.0 - Production on Mer. Mai 16 16:56:22 2007
Copyright (c) 1982, 2005, Oracle. All rights reserved.
You can let Export prompt you for parameters by entering the EXP
command followed by your username…
|
| 23 |
Forum: Reports & Discoverer «»
Posted on: Sat, 05 May 2007 12:05 «»
By: Littlefoot
Re: error: SQL-3114: ORA-03114: not connected to ORACLE
userid=sco tt/tiger@myDATABASE
^
|
There's a space here!So, what happens when you rename 'sco tt' to 'scott'?
|
| 24 |
Forum: Server Administration «»
Posted on: Thu, 03 May 2007 23:40 «»
By: Michel Cadot
Re: Import Specific Tables with Batch
…D:\>imp help=y
Import: Release 10.2.0.3.0 - Production on Ven. Mai 4 06:38:53 2007
Copyright (c) 1982, 2005, Oracle. All rights reserved.
You can let Import prompt you for parameters by entering the IMP
command followed by your username/…
|
| 25 |
Forum: Server Utilities «»
Posted on: Wed, 11 April 2007 09:21 «»
By: jra_kumar
File name validation
…loader.
I'm using like this :
sqlldr userid=scott/tiger control=test.ctl data=site1_110407.csv
It's working fine. Now, I have the another table which store the values like "site1" as one column and "110407" as another column…
|
| 26 |
Forum: Reports & Discoverer «»
Posted on: Mon, 09 April 2007 04:34 «»
By: zafarkarachi
Re: Error Running report in 9i
…Littlefoot
Actually i was supplying variable with the following line.
and as this is a hyperlink report in 9i deptno field is
hyperlinked.
correct syntax :
http://mycomputername:8889/reports/rwservlet?userid="scott/tiger@orcl report=…
|
| 27 |
Forum: Server Utilities «»
Posted on: Wed, 04 April 2007 09:28 «»
By: Mahesh Rajendran
Re: Import SQL Loader
….data
1
2
3
4
5
oracle@mutation#sqlldr userid=scott/tiger control=test.ctl data=t1.data
SQL*Loader: Release 9.2.0.8.0 - Production on Wed Apr 4 10:29:19 2007
Copyright (c) 1982, 2002, Oracle Corporation. All rights reserved.
Commit point …
|
| 28 |
Forum: Forms «»
Posted on: Wed, 28 March 2007 05:06 «»
By: karthi_smarty04
configuring the oracle forms
…/f90servlet?form=
D:\stv\LOGIN1.fmx&userid=scott/tiger@oracle
&buffer_records=NO&debug_messages=NO&array=YES&query_only=NO&
quiet=NO&RENDER=YES
But i want to hide the informations about(location of …
|
| 29 |
Forum: Reports & Discoverer «»
Posted on: Tue, 27 March 2007 03:15 «»
By: zafarkarachi
Error Running report in 9i
…All
I receive the following error in 9i report while running the
report on web.
when i run this report having the database on the same machine
it does not show any error. But when i use to connect to the
database which is on the other machine …
|
| 30 |
Forum: Forms «»
Posted on: Fri, 23 March 2007 03:05 «»
By: rdhaprakasam
Re: Prakash-Forms Doubt
…
http://prakash:8888/forms90/f90servlet?form=D:\icons\callbrowser.fmx&userid=SCOTT/TIGER@sical&buffer_records=NO&debug_mes sages=NO&array=YES&query_only=NO&quiet=NO&RENDER=YES&debug=YES&HOST=prakash&PORT=1338…
|
| 31 |
Forum: Weblogic & Application Server «»
Posted on: Sun, 11 March 2007 12:49 «»
By: zeshanali76
Hide USERNAME and PASSWORD in ora 9i IAS
…make a key in that file like
rep: userid=scott/tiger@alias report=%* destype=cache desformat=pdf
Now rep would work as alias ok Now then ur programmer's work start He/She would open the form from where he/she is calling report there he/she …
|
| 32 |
Forum: SQL & PL/SQL «»
Posted on: Fri, 02 March 2007 05:10 «»
By: Mahesh Rajendran
Re: loading comma seperated values through sql loader
…
oracle@mutation#
oracle@mutation#sqlldr userid=scott/tiger control=somectl.ctl
SQL*Loader: Release 9.2.0.7.0 - Production on Fri Mar 2 06:12:01 2007
Copyright (c) 1982, 2002, Oracle Corporation. All rights reserved.
Commit point reached - …
|
| 33 |
Forum: SQL & PL/SQL «»
Posted on: Wed, 21 February 2007 06:29 «»
By: Mohammad Taj
Re: Automatic Export & Automatic Shutdown - Startup DB
…
SQL> prompt host exp userid=scott/tiger tables=emp file=c:\db_&dt..dmp log=c:\db_&dt..log
host exp userid=scott/tiger tables=emp file=c:\db_17feb07.dmp log=c:\db_17feb07.log
SQL> prompt exit
exit
SQL>spool off…
|
| 34 |
Forum: Server Utilities «»
Posted on: Fri, 02 February 2007 06:31 «»
By: Mahesh Rajendran
Re: SQLLDR issue whit leading white spaces.
…rim(ltrim(:c1))"
)
C:\ora>sqlldr userid=scott/tiger control=data.ctl
SQL*Loader: Release 10.2.0.1.0 - Production on Fri Feb 2 07:29:17 2007
Copyright (c) 1982, 2005, Oracle. All rights reserved.
Commit point reached - logical record …
|
| 35 |
Forum: SQL & PL/SQL «»
Posted on: Tue, 16 January 2007 03:41 «»
By: vikram1780
Entries in Tnsnames.ora and Sqlnet.ora
…could help me in confguring Tnsnames.ora and sqlnet.ora.
I have installed oracle 8i.
instance is orcl
default userid/psw :scott/tiger
defualt port :1521
How to know the database name for defualt schema scott/tiger.
Any help really …
|
| 36 |
Forum: Server Utilities «»
Posted on: Wed, 20 December 2006 12:24 «»
By: Mahesh Rajendran
Re: Load first 2000 characters using SQL LOADER
…CHI@CAGO
OPERATIONS
oracle@mutation#sqlldr userid=scott/tiger control=d.ctl
SQL*Loader: Release 9.2.0.7.0 - Production on Wed Dec 20 13:27:06 2006
Copyright (c) 1982, 2002, Oracle Corporation. All rights reserved.
Commit point reached - …
|
| 37 |
Forum: JDeveloper, Java & XML «»
Posted on: Wed, 06 December 2006 23:40 «»
By: mfa786
oracel not connect wiht java (netbeans)
…
hi master
1.
sir i use netbeans with oracle but oracle 9i not connect i send you my class code and error
class code
=========
/*
* Waheed.java
*
* Created on December 6, 2006, 5:44 PM
import java.sql.*;
*
* @author Administrator
public…
|
| 38 |
Forum: Security «»
Posted on: Mon, 30 October 2006 05:42 «»
By: Getting thro'
UNABLE TO LOGIN
…ALLL...
I'M USING ORACLE9i IN WINDOWS PLATFORM.
I TRIED THE FOLLOWING IN THE DEFAULT SERVICE OR DB(ie; WHILE INSTALLING THE ORACLE A DB WILL BE CREATE IN THAT).
I'M UNABLE TO ACCESS THE ORACLE BY SYSTEM DEFAULT USER. EVENTHOUGH IF CREATE A NEW …
|
| 39 |
Forum: Server Utilities «»
Posted on: Fri, 27 October 2006 06:21 «»
By: Mahesh Rajendran
Re: Sqlldr issue with Oracle 8i
…external
)
oracle@mutation#sqlldr userid=scott/tiger control=somectl.ctl skip=1
SQL*Loader: Release 9.2.0.7.0 - Production on Fri Oct 27 07:23:33 2006
Copyright (c) 1982, 2002, Oracle Corporation. All rights reserved.
Commit point reached - …
|
| 40 |
Forum: Security «»
Posted on: Tue, 17 October 2006 09:38 «»
By: Mahesh Rajendran
Re: Oracle Password History
…@viral.sampat
The mentioned hack is a very known bug in 9i which was fixed in 10g.
First you need a database link and access to sys.link$.
SYS >ed
Wrote file afiedt.buf
1 create database link dblink_10g
2 connect to scott identified by …
|
Blog
Search
Help
Members
Register
Login
Home